<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<?php
session_start();
  if(empty($_SESSION["loginusername"]))
{
	Header("Location: firstphp.php");
}

if(!empty($_SESSION["userType"]))
  {
	$userType = $_SESSION["userType"];
  }
?>
<html >
<head>

    <title>View Attendance</title>
<link rel="stylesheet" href="http://localhost/Eldercare/jquery/style.css" type="text/css" media="screen"/>
	<link href="http://localhost/Eldercare/finalstyle.css" rel="stylesheet" type="text/css" media="all" />
<link rel="stylesheet" type="text/css" href="http://localhost/Eldercare/jquery/easyui.css">
	<link rel="stylesheet" type="text/css" href="http://localhost/Eldercare/jquery/icon.css">
	<script type="text/javascript" src="http://localhost/Eldercare/jquery/jquery-1.6.1.min.js"></script>
	<script type="text/javascript" src="http://localhost/Eldercare/jquery/jquery.easyui.min.js"></script>
	<script type="text/javascript">
		function doSearch(){
			$('#tt').datagrid('load',{
				NRIC: $('#NRIC').val(),
                                CustomerName:$('#CustomerName').val(),
				SignInTimeStamp: $('#SignInTimeStamp').val(),
				CentreLocation : $('#CentreLocation').val()
				
			});
		}
		function findAll(){
			$('#tt').datagrid('load',{
				
			});
		}
                function removeAtt() {
                var row = $('#tt').datagrid('getSelected');
                if (row) {
                    $.messager.confirm('Confirm Delete Attendance', 'Are you sure you want to remove this attendance record?', function(r) {
                        if (r) {
                            $.post('Attendance/removeattendance.php', {AttendanceRecordID: row.AttendanceRecordID}, function(result) {
                                if (result.success) {
                                    $('#tt').datagrid('reload');	// reload the user data
                                } else {
                                    $.messager.show({// show error message
                                        title: 'Deletion Disallowed',
                                        msg: result.msg
                                    });
                                }
                            }, 'json');
                        }
                    });
                }
            }
	</script>
	  <style type="text/css">
            .button 
            {
                background-color:beige;
                cursor:pointer; }
        </style>
</head>
<body>
    <div class="banner"></div>
   <div id="main">
       <div class="left-wrapper">
                <div class="logo">
                </div>
                <div class="menu-wrapper">
                    <div id='cssmenu' >     
                        <ul>
       <?php
                                if ($userType == "Therapy Assistant") {
                                    //if TA
                                    echo "<li class='has-sub' class='active'><a href='http://localhost/Eldercare/AttendanceHome.php'><span>Attendance</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/AttendanceHome.php'><span>Attendance Taking</span></a></li>
			 <li class='last'><a href='http://localhost/Eldercare/ViewAttendanceRecord.php'><span>View Attendance</span></a></li>
			 </ul>
			  </li>
			  <li class='has-sub'><a href='#'><span>Profile</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/Client.php'><span>Existing Client</span></a></li>
         <li class='last'><a href='http://localhost/Eldercare/WClient.php'><span>Withdrawn Client</span></a></li>
      </ul>
   </li>
   <li class='has-sub'><a href='http://localhost/Eldercare/ActRecords.php'><span>Activities</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/ActRecords.php'><span>Activity Recording</span></a></li>
		 <li class='last'><a href='http://localhost/Eldercare/ViewActRecord.php'><span>View Activity Records</span></a></li>
      </ul>
   </li>
   <li class='has-sub'><a href='#'><span>Reports</span></a>
   <ul>
   <li><a href='http://localhost/Eldercare/Reports.php'><span>Attendance Reports</span></a></li>
   <li class='last'><a href='http://localhost/Eldercare/ActReports.php'><span>Activity Reports</span></a></li>
   </ul>
   </li>
   <li class='last'><a href='http://localhost/Eldercare/ManagePassword.php'><span>Change Passwords</span></a></li>
     
			 ";
                                } else if ($userType == "Centre Manager") {
                                    echo "
			<li class='has-sub' class='active'><a href='http://localhost/Eldercare/AttendanceHome.php'><span>Attendance</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/AttendanceHome.php'><span>Attendance Taking</span></a></li>
			 <li><a href='http://localhost/Eldercare/ViewAttendanceRecord.php'><span>View Attendance</span></a></li>
			<li><a href='http://localhost/Eldercare/BackDate.php'><span>BackDate</span></a></li>
			<li class='last'><a href='http://localhost/Eldercare/VerifyAttendance.php'><span>Verify Attendance</span></a></li>
			</ul>
			<li class='has-sub'><a href='#'><span>Profile</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/Client.php'><span>Existing Client</span></a></li>
         <li><a href='http://localhost/Eldercare/WClient.php'><span>Withdrawn Client</span></a></li>
         <li class='last'><a href='http://localhost/Eldercare/User.php'><span>User</span></a></li>
      </ul>
   </li>
   <li class='has-sub'><a href='http://localhost/Eldercare/ActRecords.php'><span>Activities</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/ActRecords.php'><span>Activity Recording</span></a></li>
         <li class='last'><a href='http://localhost/Eldercare/ViewActRecord.php'><span>View Activity Records</span></a></li>
      </ul>
   </li>
   <li class='has-sub'><a href='#'><span>Reports</span></a>
   <ul>
   <li><a href='http://localhost/Eldercare/Reports.php'><span>Attendance Reports</span></a></li>
   <li class='last'><a href='http://localhost/Eldercare/ActReports.php'><span>Activity Reports</span></a></li>
   </ul>
   </li>
    <li class='has-sub'><a href='#'><span>Password</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/ManagePassword.php'><span>Change Passwords</span></a></li>
         <li class='last'><a href='http://localhost/Eldercare/ForgetPasswords.php'><span>Forget Password</span></a></li>
      </ul>
   </li>
			";
                                } else {
                                    echo "
			<li class='has-sub' class='active'><a href='http://localhost/Eldercare/AttendanceHome.php'><span>Attendance</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/AttendanceHome.php'><span>Attendance Taking</span></a></li>
			 <li><a href='http://localhost/Eldercare/ViewAttendanceRecord.php'><span>View Attendance</span></a></li>
			<li><a href='http://localhost/Eldercare/BackDate.php'><span>BackDate</span></a></li>
			<li class='last'><a href='http://localhost/Eldercare/VerifyAttendance.php'><span>Verify Attendance</span></a></li>
			</ul>
			<li class='has-sub'><a href='#'><span>Profile</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/Client.php'><span>Existing Client</span></a></li>
         <li><a href='http://localhost/Eldercare/WClient.php'><span>Withdrawn Client</span></a></li>
         <li><a href='http://localhost/Eldercare/User.php'><span>User</span></a></li>
         <li class='last'><a href='http://localhost/Eldercare/Centres.php'><span>Centres</span></a></li>
      </ul>
   </li>
   <li class='has-sub'><a href='http://localhost/Eldercare/ActRecords.php'><span>Activities</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/Activities.php'><span>Manage Current Activities</span></a></li>
         <li><a href='http://localhost/Eldercare/ActRecords.php'><span>Activity Recording</span></a></li>
         <li class='last'><a href='http://localhost/Eldercare/ViewActRecord.php'><span>View Activity Records</span></a></li>
      </ul>
   </li>
   <li><a href='http://localhost/Eldercare/Holidays.php'><span>Holiday</span></a></li>
<li class='has-sub'><a href='#'><span>Reports</span></a>
   <ul>
   <li><a href='http://localhost/Eldercare/Reports.php'><span>Attendance Reports</span></a></li>
   <li class='last'><a href='http://localhost/Eldercare/ActReports.php'><span>Activity Reports</span></a></li>
   </ul>
   </li>
    <li class='has-sub'><a href='#'><span>Password</span></a>
      <ul>
         <li><a href='http://localhost/Eldercare/ManagePassword.php'><span>Change Passwords</span></a></li>
         <li class='last'><a href='http://localhost/Eldercare/ForgetPasswords.php'><span>Forget Password</span></a></li>
      </ul>
   </li>
			";
                                }
                                ?>
</ul>
</div>
<div class="clear"></div></div></div>
       <div class="content">
           <div class="content2">
           <b style="float:right; margin: 0px 0 0 0">  <?php
  //session_start();
  if(!empty($_SESSION["centreName"]))
  {   
  	  $Username = $_SESSION["loginusername"];
	  $centreName = $_SESSION["centreName"];
	  echo "Welcome, " . $Username . " ! <br>" . $centreName. " Branch";
  }
  else
  {
		$Username = $_SESSION["loginusername"];
	 echo "Welcome, " . $Username;
  }?>
    <?php

?>
<?php
//session_start();
// set timeout period in seconds
$inactive = 7200;
// check to see if $_SESSION['timeout'] is set
if(isset($_SESSION["timeout"])) {
	$session_life = time() - $_SESSION["timeout"];
	if($session_life > $inactive)
        {
			session_destroy(); 
			Header("Location: Timeout.php"); 
		}
}
$_SESSION["timeout"] = time();
?>

<input type="submit" class="button" value="Logout" onclick="parent.location='logout.php'"></b>
</p><div class="clear"></div>
<h3>Attendance Records </h3>

<p></p>
<p></p>
<table id="tt" class="easyui-datagrid" style="width:auto;height:auto"
			url="Attendance/viewattendance.php"
			title="Searching" iconCls="icon-search" toolbar="#tb"
			rownumbers="true" pagination="true" rownumbers="true" fitColumns="true" singleSelect="true">
		<thead>
			<tr>
				<th field="NRIC" width="50">NRIC</th>
				<th field="CustomerName" width="50">Client Name</th>
				<th field="CentreName" width="50">Centre Name</th>
				<th field="SignInTimeStamp" width="50" align="right">Sign In Time Stamp</th>
				<th field="SignOutTimeStamp" width="50" align="right">Sign Out Time Stamp</th>
				<th field="Status" width="50">Status</th>
                                <tbody style="display:none">
                                <th field="AttendanceRecordID" width="50" >AttendanceRecordID</th></tbody>
			</tr>
		</thead>
	</table>
	<div id="tb" style="padding:3px"><?php
            if ($userType != "Therapy Assistant") { echo"
            <a href='#' class='easyui-linkbutton' iconCls='icon-remove' plain='true' onclick='removeAtt()'>Remove</a>";
            }?>
		<span>NRIC:</span>
		<input id="NRIC" style="line-height:26px;border:1px solid #ccc">
                <span>Name: </span>
                <input id="CustomerName" style="line-height:26px;border:1px solid #ccc">
		<span>Date:</span> 
		<input id="SignInTimeStamp" style="line-height:26px;border:1px solid #ccc" type = "date">
		<?php
		if($userType=="System Admin")
		{
			echo "<span>Centre:</span>
<select name='CentreLocation' id = 'CentreLocation' class='empty'>
  <option value='0'selected >Select a Centre</option>";
  
	mysql_connect("localhost","root","");
	mysql_select_db("eldercaredb");
	$centreDetail="SELECT CentreId, CentreName FROM centre";
	$query_result=mysql_query($centreDetail);
	while($result = mysql_fetch_assoc($query_result))
	{
	
		echo "<option value=";echo $result['CentreId'];echo">";echo $result['CentreName'];echo"</option>";
		
		
	}
	echo"
	</select>";
		}
		?>
		
		<a href="#" class="easyui-linkbutton" iconCls="icon-search" onClick="doSearch()">Search</a>
		<a href="#" class="easyui-linkbutton" onClick="findAll()">All</a>
	</div>
</div><div class="clear"></div></div>
</div>
</body> </div>
</html>